UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tMA9jnYubeHayOptv6tAK4U6C5XfUvBhwmbWVVUaG/I='
WHERE
key_id = 'e7ca49153544060065a96400ae1f6faffda2f04a5865f204786b9e5bc773c5fa'
AND (
token = 'tMA9jnYubeHayOptv6tAK4U6C5XfUvBhwmbWVVUaG/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)