UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'deOU8DYn/+NtkF0oNa5MLQil4lvOj9i6GkYUnl/v9VY='
WHERE
key_id = 'ef33ba01e1eb653432866a6df63787f9238a0c745f38e425bd4263d843778a7d'
AND (
token = 'deOU8DYn/+NtkF0oNa5MLQil4lvOj9i6GkYUnl/v9VY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)