UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4rXNr54M3o9HGxiwmJVvapNHASEKB86F6UzCzzJxamw='
WHERE
key_id = '5b1a575fc0fc9adc57c247c9cea7aeea26d6804566d2348cb217159adb6b0a51'
AND (
token = '4rXNr54M3o9HGxiwmJVvapNHASEKB86F6UzCzzJxamw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)