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