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