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