UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SCqKCfPfoy5WzFn81vfZOLGnDZ7byLHf0nJ1zosB4lg='
WHERE
key_id = '0526a1562252de9407287e3aef47e6a8d5dbc1dd0d459c099052003006329766'
AND (
token = 'SCqKCfPfoy5WzFn81vfZOLGnDZ7byLHf0nJ1zosB4lg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)