UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Yxr+EPax47VHoKbPNoJLA+0TmlI2DOJl41mQoG4FNi0='
WHERE
key_id = '8f646e6d7bba06a278072bcff8926e63722d47e59a9e44bdb6cd80fd8b3272ec'
AND (
token = 'Yxr+EPax47VHoKbPNoJLA+0TmlI2DOJl41mQoG4FNi0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)