UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bsK21QTdkzoAGG7spgt4VKKWo5cQBaQCjBPfGRkUV3M='
WHERE
key_id = 'a1bb0ec64331ab61a80a548a8b298b78565fce0c5e137a4841d14500e37774e9'
AND (
token = 'bsK21QTdkzoAGG7spgt4VKKWo5cQBaQCjBPfGRkUV3M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)