UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bKU4fREcpgIGYLXABaQXv3iGzxNNTtXckt8FqZ53uk0='
WHERE
key_id = '11dd19ff49d49d54e77aff40173fab3e01cf166349a64d19fc688cb779ce16df'
AND (
token = 'bKU4fREcpgIGYLXABaQXv3iGzxNNTtXckt8FqZ53uk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)