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