UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PBNiOztwA0XAbFaWVaSOtguGEjCwqmzTeqyQDTqWETo='
WHERE
key_id = '86ed59b44844fd3874c54cb3361a60cfa1a71a2d3ea88cafebf605a50c710cec'
AND (
token = 'PBNiOztwA0XAbFaWVaSOtguGEjCwqmzTeqyQDTqWETo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)