UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NmZvi3NVgyM2Vf1pkZ7EXErkpi2w895cjJDrleke6Uw='
WHERE
key_id = 'ae41f6ffdb9ed84028db48021b9a0cb7a033a94bd6b9c7e339f45d351afed9d8'
AND (
token = 'NmZvi3NVgyM2Vf1pkZ7EXErkpi2w895cjJDrleke6Uw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)