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