UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p46Q8c2Nf95lb9imvBs9Cb+mBA+JVKZSNyduc8EhMyg='
WHERE
key_id = 'f9bb2c87c93f733388ee8fac32a0893258f44f264339805d0b42960691d71262'
AND (
token = 'p46Q8c2Nf95lb9imvBs9Cb+mBA+JVKZSNyduc8EhMyg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)