UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0AVnrSWb2PacSgsxxrDBuVfc53N19HjO8/HzjWPJTl8='
WHERE
key_id = 'a8b7ec301a800c6c1431249f0a8d284a1a0a0fb5cac694e8c32c107e56266a30'
AND (
token = '0AVnrSWb2PacSgsxxrDBuVfc53N19HjO8/HzjWPJTl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)