UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1KlhWoxxj5xrFHVoLxMMdtfS3fDEm5dnbuXMnAWEhhg='
WHERE
key_id = 'a1685d6a6def6c9e7406932ed415d0faba4b98bf958b049d863d8e9ac7811fab'
AND (
token = '1KlhWoxxj5xrFHVoLxMMdtfS3fDEm5dnbuXMnAWEhhg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)