UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pvmd6cJsyQ8w238Y2iZXEc2fkVlAQoRlx4wLhf5VZjs='
WHERE
key_id = '5d4157f2cf8b31be186e4126296b07e50b7a87a51208494b265ad8973dd5ecf0'
AND (
token = 'pvmd6cJsyQ8w238Y2iZXEc2fkVlAQoRlx4wLhf5VZjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)