UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47NB0nHlxi/hbaj56BYKJexm0kAx/B6KkTTiQeUTA5U='
WHERE
key_id = '1d4aa6a34e5f9b805a2562915eb9b72590fb95f456a72ad6dd60b9994d62e594'
AND (
token = '47NB0nHlxi/hbaj56BYKJexm0kAx/B6KkTTiQeUTA5U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)