UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bUxwbGE/6/EVX8n65QYKI7pvLxqSg88SZsgVexc5vN8='
WHERE
key_id = '1738a6d5c3d9e5e06519351c4c2edbe0ef09abdc4f13c5034363b79f215ebf3f'
AND (
token = 'bUxwbGE/6/EVX8n65QYKI7pvLxqSg88SZsgVexc5vN8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)