UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qactamO0vgCFYJ1KHCKEUQ5pmGu8c1OZpZU60d+LSmA='
WHERE
key_id = 'e5eeedd02b8c19201825adf14c0b309d1fa34e20699f1c5bb8618694dc1fd4f8'
AND (
token = 'qactamO0vgCFYJ1KHCKEUQ5pmGu8c1OZpZU60d+LSmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)