UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WA16gxddG9Dhifr+iYi1LwyWuPqAW5mMv+TX1FRLAmA='
WHERE
key_id = 'e75942ca99e394f2473f254b15c1186dc761818f88b2aca66e33765bbce09771'
AND (
token = 'WA16gxddG9Dhifr+iYi1LwyWuPqAW5mMv+TX1FRLAmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)