UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'crKdi8KiwwYx9B+ZQoyockfJ8Cewi7IficJgUQ/pGq0='
WHERE
key_id = 'e561180fd184d7d08c3e4cf2b348a370f68c089dd55c138fccfad3c687a75195'
AND (
token = 'crKdi8KiwwYx9B+ZQoyockfJ8Cewi7IficJgUQ/pGq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)