UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CESCh4lYLzf8E9FJATbxr3spXoRhrDr25uHriP2EBwA='
WHERE
key_id = '0da206e178689791991ecd776964a82b1ee4565766d267cc306e7e78a82d8fca'
AND (
token = 'CESCh4lYLzf8E9FJATbxr3spXoRhrDr25uHriP2EBwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)