UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9g65cd/c+i+pb3g049iKhSrk6mKnX8gQ7ZPPKpOkhU='
WHERE
key_id = 'd15ab5ee587a689d21c89c061dc86332c247aebf54bf2140eb84dbeae5251227'
AND (
token = 'D9g65cd/c+i+pb3g049iKhSrk6mKnX8gQ7ZPPKpOkhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)