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