UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4p0PW8p5XPOnBKAaaHlXvnBsMkU7FL30/eSBR+LEpAo='
WHERE
key_id = '3d2e5f5cd17bdcbaeb189a30a9a9598bd9054de8e237b73743b37856edebc842'
AND (
token = '4p0PW8p5XPOnBKAaaHlXvnBsMkU7FL30/eSBR+LEpAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)