UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3YBAdFRw9oov2Gzho7zuQh8faH3/az7/0XRfXg4errU='
WHERE
key_id = '7954c28e18af2844c585b8831b4506b8ad79acd654e4d5e63f34072fb3012b0b'
AND (
token = '3YBAdFRw9oov2Gzho7zuQh8faH3/az7/0XRfXg4errU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)