UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7t8AKfa9IheHm31L8SBSZEvr422fRWTId8YBM+bHEE='
WHERE
key_id = '5b09f94d8d594a9dc68570b47ca9357b2181edbfe95227ef86bfefd00319f492'
AND (
token = 'r7t8AKfa9IheHm31L8SBSZEvr422fRWTId8YBM+bHEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)